Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
parent (FK)(PK) | A category of container that defines what it is made of, its type (primarily its material handling category - e.g. 55 gallon drums, pallets, cases, etc.) and its shape. | CD_CNR_TYP_PRNT | Code | varchar(20) | SupplierItemReceivingUnit(AS_UNI_SPR_ITM_RCV) |
child (FK)(PK) | A category of container that defines what it is made of, its type (primarily its material handling category - e.g. 55 gallon drums, pallets, cases, etc.) and its shape. | CD_CNR_TYP_CHLD | Code | varchar(20) | SupplierItemReceivingUnit(AS_UNI_SPR_ITM_RCV) |
ConversionFactorCount | The number of units within each shipment container. This factor is multiplied by the number of containers to provide the total number of units. | FA_FCT_CVN | Quantity | DECIMAL(9,3) | |
ConversionToRetailSaleUnitCount | The number of retail units calculated by multiplying the conversion factor count and the number of containers. | FA_SL_CVN_TO_RT | Quantity | DECIMAL(9,3) | |